<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html>
<head>
<title>SQLite tutorial</title>
<link rel="stylesheet" href="/cfg/format.css" type="text/css">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="keywords" content="SQLite3, SQLite, database, tutorial, command line tool, learn SQLite">
<meta name="description" content="This is SQLite3 tutorial. In this tutorial, you will
learn the fundamentals of the SQLite database system.">
<meta name="language" content="en">
<meta name="author" content="Jan Bodnar">
<meta name="distribution" content="global">

<script type="text/javascript" src="/lib/jquery.js"></script>
<script type="text/javascript" src="/lib/common.js"></script>

<script type="text/javascript">
  (function() {
    var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
    po.src = 'https://apis.google.com/js/plusone.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
  })();
</script>

<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-5536206-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>

</head>

<body>

<div class="container2">

<div id="wide_ad" class="ltow">
<script type="text/javascript"><!--
google_ad_client = "pub-9706709751191532";
/* 160x600, August 2011 */
google_ad_slot = "2484182563";
google_ad_width = 160;
google_ad_height = 600;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>

<div class="content2">

<a href="/" title="Home">Home</a>


<h1>SQLite tutorial</h1>

<p>
This is SQLite tutorial. It covers the SQLite database engine, sqlite3 command line tool and 
the SQL language covered by the database engine.
</p>

<h2>Table of contents</h2>

<ul>
<li><a href="introduction/">Introduction</a></li>
<li><a href="tool/">The sqlite3 command line tool</a></li>
<li><a href="tables/">Creating, altering and dropping tables</a></li>
<li><a href="expressions/">SQLite expressions</a></li>
<li><a href="datamanipulation/">Inserting, updating and deleting data</a></li>
<li><a href="select/">The SELECT statement</a></li>
<li><a href="constraints/">Constraints</a></li>
<li><a href="joins/">Joining tables</a></li>
<li><a href="sqlitefunctions/">SQLite functions</a></li>
<li><a href="viewstriggerstransactions/">Views, triggers, transactions</a></li>
</ul>

<h2>SQLite</h2>

<p>
SQLite is an embedded relational database engine. Its developers call it a self-contained, 
serverless, zero-configuration and transactional SQL database engine.
</p>

<div class="g-plusone"></div>

<h2>Similar tutorials</h2>

<p>
<a href="/databases/mysqltutorial/">MySQL tutorial</a>
<br>
<a href="/db/sqlitepythontutorial/">SQLite Python tutorial</a>
<br>
<a href="/db/sqlitephp/">SQLite PHP tutorial</a>
<br>
<a href="/db/sqliteperltutorial/">SQLite Perl tutorial</a>
<br>
<a href="/db/sqliteruby/">SQLite Ruby tutorial</a>
<br>
<a href="/db/sqlitecsharp/">SQLite C# tutorial</a>
<br>
<a href="/db/sqlitevb/">SQLite Visual Basic tutorial</a>
</p>

<div class="footer">

<div class="signature">
<a href="/">ZetCode::</a> last modified January 8, 2013 <span class="copyright">&copy; 2007 - 2013 Jan Bodnar</span>
</div>
</div> 

</div> <!-- content -->

</div> <!-- container -->

</body>
</html>
